Loading…
Back To Schedule
Monday, May 16 • 9:00am - 12:00pm
PostgreSQL Internals for Oracle, MySQL DBAs and Beginners

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Feedback form is now closed.
This tutorial is focused on teaching PostgreSQL to professionals who are already experienced with Oracle or MySQL. As we discuss from the basics, even a beginner may adapt the concepts easily.

Here are the main points covered in this tutorial:

  • Brief history of PostgreSQL and its features
  • PostgreSQL Architecture for MySQL/Oracle DBAs and beginners.
  • Basics of PostgreSQL including Installation, Data Directory, and Managing a Cluster.
  • Architecture and Internals.
  • MVCC, AUTOVACUUM, and Transaction ID Wraparound in PostgreSQL
  • User Management
  • Types of Indexes
  • Logical and Physical Backups and PITR
  • Declarative Partitioning.
Speakers
avatar for Avinash Vallarapu

Avinash Vallarapu

CEO and Database Performance Tech Lead, MigOps
Avinash Vallarapu (Avi) is the CEO of MigOps (a company specializing in Migrations to PostgreSQL and PostgreSQL Consulting). Before joining MigOps, Avi worked as a Global Services Tech Lead for PostgreSQL services at Percona, Database Architect at OpenSCG, and Dell International Services... Read More →

Monday May 16, 2022 9:00am - 12:00pm CDT
Classroom 203 M2
  Tutorial

Attendees (49)